create external table jms_dim.dim_sys_customer_entity_base_dt
(
    id            string,
    city_id        bigint comment '城市id',
    area_id        bigint comment '区域id',
    address        string comment '地址',
    province_id    bigint comment '省份id',
    contact_name   string comment '联系人姓名',
    contact_mobile string comment '联系人手机',
    type_id        bigint comment '客户类型',
    settlement_id  bigint comment '结算方式：寄付月结、寄付现结',
    nature_id      bigint comment '客户性质:国有、民营、股份制、外资、社会组织机构',
    update_by_code string comment '更新人编码',
    update_by_name string comment '更新人名称',
    update_time    TIMESTAMP comment '更新时间',
    create_by_code string comment '创建人编码',
    create_by_name string comment '创建人名称',
    create_time    TIMESTAMP comment '创建时间',
    is_delete      tinyint comment '是否删除 1是 2否',
    code           string comment '实体编号',
    network_id     bigint comment '网点id',
    network_code   string comment '网点id',
    name           string
)comment '客户实体清洗表'
PARTITIONED BY (
  `dt` string COMMENT '时间分区')
ROW FORMAT SERDE
  'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
STORED AS INPUTFORMAT
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
OUTPUTFORMAT
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION
  '/dw/hive/jms_dim.db/external/dim_sys_customer_entity_base_dt';

